package com.thomas.sharing.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import com.thomas.sharing.mybatis.model.Brand;

public interface CarMapper {
	
	@Select("SELECT DISTINCT BRANDNAME as id, BRANDNAME as name FROM THOMASDB.CAR ORDER BY id")
	public List<Brand> getBrands();
}
